UNRECOVERABLE
LOAD DATA
INFILE './$fileName'
Append INTO TABLE smsapp2.LOAD_TABLE_ASCII FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
( PARSE_ACCPT_CALL_REFF,FILENAME,RECTYPE,STRUCT_CODE,CLG_NPI,CLG_NUMBER,CLG_CUST_ID,CLD_NPI,CLD_NUMBER,CLD_CUST_ID,START_TIME Date 'DD/MM/YYYY HH24:MI:SS',END_TIME Date 'DD/MM/YYYY HH24:MI:SS',STATUS,MSG_LENGTH,PRIORITY,DEFERRED,RECEIPT,NBATTEMPT,PROT_ID,CLG_MSC_FLAG,CLG_MSC_GT,CLD_MSC_FLAG,CLD_MSC_GT,MAP_ERROR,ERR_MSG,ERR_STATUS,CLG_IMSI,CLD_IMSI,PROC_FLAG,CLG_FLAG,CLD_FLAG,LOCAL_ERROR )
